﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Specialized;

namespace Ylh.DAL
{
    public abstract class HelpBase
    {

        public abstract int ExecuteNonQuery(String CmdText, CommandType CmdType, NameValueCollection NameValues, String ConStr);
        public abstract int ExecuteNonQuery(String CmdText, CommandType CmdType, Dictionary<string, object> PreWhere, String ConStr);

        public abstract DataTable ExecuteQuery(String CmdText, CommandType CmdType, Dictionary<string, object> PreWhere, String ConStr);
        public abstract DataTable ExecuteQuery(String CmdText, CommandType CmdType, NameValueCollection NameValues, String ConStr);
        public abstract DataTable ExecuteStrQuery(String CmdText, CommandType CmdType, String ConStr);

        public abstract int InsertDataTable(String SelectCmd, DataTable dt, String TableName, List<string> IExcept, String ConStr);
        public abstract int UpdateDataTable(string StrSelectCmd, DataTable dt, String TableName, List<string> PrimaryKeyList, List<string> UpdateColumn, string ConStr);
    }
}
